select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (a.houseprice >= 20000 and a.houseprice <= 30000) and c.enDistrictName = 'Huangpu' and b.pid in (select x.pid from [base_property] x,[base_districtArea] y where x.aid=y.id and y.enAreaName = 'People Square') order by updateTime Desc, a.dftpic desc
Western deco with high quality equipements, double door frige, gas stove,dish washer, oven all with very famous brand. 2bedrooms with 2bathrooms, with 50sqm pri...